﻿<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>App管理系统-安装</title>
<style type="text/css">
<!--
html,body{margin:0px; padding:0px; margin-left:auto; margin-right:auto; text-align:center; font-size:12px; font-family:"微软雅黑";}
body{background-color:#EAEAEA;color:#F0F0F0;}
a {color: #ffffff;text-decoration:none;}
a:hover {color: #98be01;text-decoration: none;}
.wenzi {color:#333333;}
.message{color:darkorange;padding:10px;font-size:13px;}
-->
</style>
</head>

<body>
<div align="center"> 
    <p>&nbsp;</p>
    <p>&nbsp;</p>
    <p style="color:#009900; font-size:22px;">App管理系统-安装</p>
    <table width="500" border="0" cellpadding="5" cellspacing="1" bgcolor="#C9C9C9" class="wenzi">
	<form id="form1" name="form1" method="post" action="install.php">
      <tr>
        <td width="167" bgcolor="#FFFFFF"><div align="right">Mysql数据库服务器：</div></td>
        <td width="310" bgcolor="#FFFFFF"><div align="left">
          <input name="hostname" type="text" id="hostname" size="30" />
        </div></td>
      </tr>
      <tr>
        <td bgcolor="#FFFFFF"><div align="right">Mysql数据库用户名：</div></td>
        <td bgcolor="#FFFFFF"><div align="left">
          <input name="username" type="text" id="username" size="30" />
        </div></td>
      </tr>
      <tr>
        <td bgcolor="#FFFFFF"><div align="right">Mysql数据库密码：</div></td>
        <td bgcolor="#FFFFFF"><div align="left">
          <input name="psw" type="text" id="psw" size="30" />
        </div></td>
      </tr>
      <tr>
        <td bgcolor="#FFFFFF"><div align="right">Mysql数据库名：</div></td>
        <td bgcolor="#FFFFFF"><div align="left">
          <input name="dbname" type="text" id="dbname" size="30" />
        </div></td>
      </tr>
      <tr>
        <td bgcolor="#FFFFFF"><div align="right">后台管理员用户名：</div></td>
        <td bgcolor="#FFFFFF"><div align="left">
          <input name="admin" type="text" id="admin" size="30" />
        </div></td>
      </tr>
      <tr>
        <td bgcolor="#FFFFFF"><div align="right">后台管理员密码：</div></td>
        <td bgcolor="#FFFFFF"><div align="left">
          <input name="adminpass" type="text" id="adminpass" size="30" />
        </div></td>
      </tr>
      <tr>
        <td height="40" colspan="2" bgcolor="#FFFFFF"><div align="center">
          <input type="submit" name="Submit" value="开始安装" />
        </div>
        <div align="left"></div></td>
      </tr>
    </form>
    </table>
    <div class="message">
<?php




/*
出于安全考虑，禁用系统初始化安装
 */
//echo "<p><b style='color:darkred;'>当前页面仅用于系统初始化安装, 出于安全的考虑,已经禁用初始化安装步骤,如果确实需要对系统初始化安装，请注释掉相关代码或者联系管理员</b></p>";exit(0);





function check($str){
return str_replace("'","''",$str);
}
$hostname=check(addslashes(sprintf("%s",@$_POST["hostname"])));
$username=check(addslashes(sprintf("%s",@$_POST["username"])));
$psw=check(addslashes(sprintf("%s",@$_POST["psw"])));
$dbname=check(addslashes(sprintf("%s",@$_POST["dbname"])));
$admin=check(addslashes(sprintf("%s",@$_POST["admin"])));
$adminpass=check(addslashes(sprintf("%s",@$_POST["adminpass"])));
// echo $hostname;
// echo $username;
// echo $psw;
// echo $dbname;
// echo $admin;
// echo $adminpass;
if(empty($hostname)||empty($username)||empty($psw)||empty($admin)||empty($adminpass)){
echo "请填写完整再提交";
}else{
$conn = mysql_connect($hostname,$username,$psw)or die(mysql_error());
mysql_select_db($dbname, $conn) or die(mysql_error());
echo "ok";
$word="<?php\r\n\$cfg_dbhost='".$hostname."';\r\n\$cfg_dbuser='".$username."';\r\n\$cfg_dbpwd='".$psw."';\r\n\$cfg_dbname='".$dbname."';\r\n?>";
$fh=fopen("config.php", "w");
fwrite($fh, $word);
fclose($fh);
//创建管理员表
$sql = "CREATE TABLE ph_admin(ID int NOT NULL AUTO_INCREMENT,PRIMARY KEY(ID),admin varchar(500),adminpass varchar(500),thetype varchar(500))";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_admin(admin,adminpass,thetype)VALUES('".$admin."','".$adminpass."','管理员')";
mysql_query($sql,$conn);
//创建W网站订单表
// $sql = "CREATE TABLE ph_orderw(ID int NOT NULL AUTO_INCREMENT,PRIMARY KEY(ID),orderId varchar(500),orderDate varchar(500),itemCode varchar(500),lotnumber varchar(500),senderName varchar(500),senderKana varchar(500),senderAddress text,senderZipCode varchar(500),senderPhoneNumber varchar(500),settlementName varchar(500),totalItemPrice varchar(500),postagePrice varchar(500),totalPrice varchar(500),itemOption varchar(500),mailAddress varchar(500),siteAndDevice varchar(500),sellMethodSegment varchar(500),paymentStatus varchar(500),paymentDate varchar(500),userComment varchar(500),orderStatus varchar(500),unit varchar(500),requestPrice varchar(500),settleStatus varchar(500),pgResult varchar(500),pgResponseDetail varchar(500),shipnumber varchar(500),quantity int,weight float,amount float,cdate varchar(500),user_name varchar(500),beizhu text,caigoutime varchar(500),caigoulink varchar(500),buhuolink varchar(500),status varchar(500),cnamount varchar(500),comamount varchar(500))";
// mysql_query($sql,$conn);
// //创建Y网站订单表
// $sql = "CREATE TABLE ph_ordery(ID int NOT NULL AUTO_INCREMENT,PRIMARY KEY(ID),OrderId varchar(500),myid varchar(500),LineId varchar(500),ItemId varchar(500),Quantity int,SubCodeOption varchar(500),OrderTime varchar(500),OrderStatus varchar(500),EntryPoint varchar(500),ShipName varchar(500),ShipAddress1 text,ShipAddress2 text,ShipCity varchar(500),ShipPrefecture varchar(500),ShipZipCode varchar(500),ShipPhoneNumber varchar(500),ShipRequestDate varchar(500),ShipRequestTime varchar(500),ShipNotes varchar(500),BillMailAddress varchar(500),PayMethodName varchar(500),PayStatus varchar(500),PayDate varchar(500),QuantityDetail varchar(500),ShipCharge varchar(500),PayCharge varchar(500),TotalPrice varchar(500),shipnumber varchar(500),shipquantity int,weight float,amount float,cdate varchar(500),user_name varchar(500),beizhu text,caigoutime varchar(500),caigoulink varchar(500),buhuolink varchar(500),status varchar(500),cnamount varchar(500),comamount varchar(500))";
// mysql_query($sql,$conn);
$sql = "CREATE TABLE ph_order(ID int NOT NULL AUTO_INCREMENT,PRIMARY KEY(ID),App varchar(500),Country varchar(500),Keyword varchar(500),Last_rank varchar(500),Installs varchar(500),Split varchar(500),Ratings varchar(500),rating_stars varchar(500),ipad_order varchar(500),language varchar(500),Reviews varchar(500),Reviews_stars varchar(500),Price varchar(500),Status varchar(500),Order_date varchar(500),userid varchar(500),orderno varchar(500))";
mysql_query($sql,$conn);

$sql = "CREATE TABLE ph_reviews(ID int NOT NULL AUTO_INCREMENT,PRIMARY KEY(ID),title varchar(500),content varchar(500),orderno varchar(500))";
mysql_query($sql,$conn);

// $sql = "CREATE TABLE ph_orderyw(ID int NOT NULL AUTO_INCREMENT,PRIMARY KEY(ID),orderId varchar(500),userid varchar(500),shipnumber varchar(500),cnshipnumber varchar(500),proimg varchar(500),Quantity int,proname varchar(500),procolor varchar(500),prodes varchar(500),custPhone varchar(500),custjpname varchar(500),custenname varchar(500),custzip varchar(500),custaddress varchar(500),weight varchar(500),tjwight varchar(500),bpwight varchar(500),dwname varchar(500),dwaddress varchar(500),sbquantity varchar(500),sbcurrency varchar(500),enproname varchar(500),material varchar(500),sjquantity varchar(500),price varchar(500),country varchar(500),des1 varchar(500),des2 varchar(500),des3 varchar(500),comamount varchar(500),tlong varchar(500),high varchar(500),width varchar(500),cdate varchar(500),countweight varchar(500),actid varchar(500),sbid varchar(500),status varchar(500))";
// mysql_query($sql,$conn);
//创建用户表
$sql = "CREATE TABLE ph_user(ID int NOT NULL AUTO_INCREMENT,PRIMARY KEY(ID),user_name varchar(500),user_pass varchar(500),usertype varchar(500),cdate varchar(500),country varchar(500),company_name varchar(500),vat varchar(500),ip varchar(500),balance float(2,2),top_up float,first_name varchar(500),last_name varchar(500),address varchar(500),postcode varchar(500),city varchar(500),email varchar(500))";
mysql_query($sql,$conn);
//创建关联表
$sql = "CREATE TABLE ph_myapp(ID int NOT NULL AUTO_INCREMENT,PRIMARY KEY(ID),app_name varchar(500),url varchar(500),cdate varchar(500),icon varchar(500),userid varchar(500))";
mysql_query($sql,$conn);
$sql = "CREATE TABLE ph_keywords(ID int NOT NULL AUTO_INCREMENT,PRIMARY KEY(ID),app_name varchar(500),country varchar(500),keywords varchar(500),userid varchar(500))";
mysql_query($sql,$conn);
$sql = "CREATE TABLE ph_transactions(ID int NOT NULL AUTO_INCREMENT,PRIMARY KEY(ID),Transaction_ID varchar(500),Amount varchar(500),Payment_Amount varchar(500),payType varchar(500),cdate varchar(500),userid varchar(500))";
mysql_query($sql,$conn);
$sql = "CREATE TABLE ph_login(ID int NOT NULL AUTO_INCREMENT,PRIMARY KEY(ID),ip varchar(500),user_name varchar(500),c_time varchar(500))";
mysql_query($sql,$conn);
$sql = "CREATE TABLE ph_action(ID int NOT NULL AUTO_INCREMENT,PRIMARY KEY(ID),user_name varchar(500),content varchar(500),c_time varchar(500))";
mysql_query($sql,$conn);
$sql = "CREATE TABLE ph_tdk(ID int NOT NULL AUTO_INCREMENT,PRIMARY KEY(ID),sitename varchar(500),Title varchar(500),Keywords varchar(500),Des varchar(500),About_Title varchar(500),About_Keywords varchar(500),About_Des varchar(500),Services_Title varchar(500),Services_Keywords varchar(500),Services_Des varchar(500),Pricing_Title varchar(500),Pricing_Keywords varchar(500),Pricing_Des varchar(500))";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_tdk(sitename,Title,Keywords,Des,About_Title,About_Keywords,About_Des,Services_Title,Services_Keywords,Services_Des,Pricing_Title,Pricing_Keywords,Pricing_Des)VALUES('sitename','Title','Keywords','Des','About_Title','About_Keywords','About_Des','Services_Title','Services_Keywords','Services_Des','Pricing_Title','Pricing_Keywords','Pricing_Des')";
mysql_query($sql,$conn);
$sql = "CREATE TABLE ph_pay(ID int NOT NULL AUTO_INCREMENT,PRIMARY KEY(ID),merNo varchar(500),terNo varchar(500),signKey varchar(500))";
mysql_query($sql,$conn);
$sql = "CREATE TABLE ph_paylevel(ID int NOT NULL AUTO_INCREMENT,PRIMARY KEY(ID),amount varchar(500),realamount varchar(500),savelevel varchar(500))";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_pay(merNo,terNo,signKey)VALUES('67001','67001001','rB6t60l8Fkd')";
mysql_query($sql,$conn);
$sql = "CREATE TABLE ph_country(ID int NOT NULL AUTO_INCREMENT,PRIMARY KEY(ID),cid varchar(500),country varchar(500))";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('1','Afghanistan')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('2','Aland islands')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('3','Albania')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('4','Algeria')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('5','American Samoa')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('6','Andorra')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('7','Angola')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('8','Anguilla')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('9','Antarctica')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('10','Antiguaand Barbuda')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('11','Argentina')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('12','Armenia')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('13','Aruba')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('14','Australia')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('15','Austria')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('16','Azerbaijan')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('17','Bahamas')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('18','Bahrain')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('19','Bangladesh')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('20','Barbados')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('21','Belarus')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('22','Belgium')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('23','Belize')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('24','Benin')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('25','Bermuda')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('26','Bhutan')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('27','Bolivia')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('28','Bosnia and Herzegovina')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('29','Botswana')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('30','Bouvet Island')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('31','Brazil')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('32','British Indian Ocean')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('33','British Virgin Islands')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('34','Brunei Darussalam')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('35','Bulgaria')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('36','Burkina Faso')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('37','Burundi')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('38','Cambodia')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('39','Cameroon')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('40','Canada')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('41','Cape Verde')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('42','Cayman Islands')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('43','Central African Republic')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('44','Chad')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('45','Chile')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('46','China')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('47','Christmas Island')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('48','Cocos (Keeling) Islands')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('49','Colombia')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('50','Comoros')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('51','Congo')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('52','Cook Islands')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('53','Costa Rica')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('54','Croatia')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('55','Cuba')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('56','Curaçao')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('57','Cyprus')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('58','Czech Republic')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('59','Democratic Republic of the Congo')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('60','Denmark')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('61','Djibouti')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('62','Dominica')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('63','Dominican Republic')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('64','East Timor')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('65','Ecuador')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('66','Egypt')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('67','El Salvador')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('68','Equatorial Guinea')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('69','Eritrea')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('70','Estonia')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('71','Ethiopia')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('72','Falkland Islands (Malvinas)')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('73','Faroe Islands')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('74','Fiji')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('75','Finland')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('76','France')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('77','French Guiana')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('78','French Polynesia')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('79','French Southern Territories')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('80','Gabon')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('81','Gambia')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('82','Georgia')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('83','Germany')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('84','Ghana')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('85','Gibraltar')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('86','Greece')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('87','Greenland')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('88','Grenada')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('89','Guadeloupe')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('90','Guam')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('91','Guatemala')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('92','Guernsey')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('93','Guinea')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('94','Guinea-Bissau')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('95','Guyana')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('96','Haiti')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('97','Heard Island and Mcdonald Islands')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('98','Honduras')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('99','Hong Kong')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('100','Hungary')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('101','Iceland')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('102','India')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('103','Indonesia')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('104','Iran')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('105','Iraq')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('106','Ireland')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('107','Isle of Man')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('108','Israel')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('109','Italy')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('110','Ivory Coast')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('111','Jamaica')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('112','Japan')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('113','Jersey')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('114','Jordan')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('115','Kazakhstan')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('116','Kenya')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('117','Kiribati')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('118','Kuwait')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('119','Kyrgyzstan')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('120','Laos')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('121','Latvia')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('122','Lebanon')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('123','Lesotho')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('124','Liberia')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('125','Libya')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('126','Liechtenstein')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('127','Lithuania')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('128','Luxembourg')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('129','Macau')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('130','Macedonia')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('131','Madagascar')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('132','Malawi')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('133','Malaysia')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('134','Maldives')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('135','Mali')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('136','Malta')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('137','Marshall Islands')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('138','Martinique')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('139','Mauritania')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('140','Mauritius')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('141','Mayotte')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('142','Mexico')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('143','Micronesia')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('144','Moldova')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('145','Monaco')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('146','Mongolia')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('147','Montenegro')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('148','Montserrat')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('149','Morocco')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('150','Mozambique')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('151','Myanmar')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('152','Namibia')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('153','Nauru')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('154','Nepal')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('155','Netherlands')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('156','New Caledonia')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('157','New Zealand')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('158','Nicaragua')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('159','Niger')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('160','Nigeria')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('161','Niue')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('162','Norfolk Island')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('163','North Korea')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('164','Northern Mariana Islands')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('165','Norway')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('166','Oman')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('167','Pakistan')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('168','Palau')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('169','Palestine')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('170','Panama')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('171','Papua New Guinea')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('172','Paraguay')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('173','Peru')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('174','Philippines')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('175','Pitcairn')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('176','Poland')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('177','Portugal')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('178','Puerto Rico')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('179','Qatar')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('180','Réunion')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('181','Romania')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('182','Russian Federation')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('183','Rwanda')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('184','Saint Barthélemy')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('185','Samoa')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('186','San Marino')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('187','Sao Tome and Principe')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('188','Saudi Arabia')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('189','Senegal')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('190','Serbia')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('191','Seychelles')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('192','Sierra Leone')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('193','Sint Maarten')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('194','Singapore')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('195','Slovakia')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('196','Slovenia')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('197','Solomon Islands')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('198','Somalia')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('199','South Africa')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('200','South Georgia and the South Sandwich islands')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('201','South Korea')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('202','South Sudan')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('203','Spain')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('204','Sri Lanka')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('205','St. Helena')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('206','St. Kitts and Nevis')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('207','St. Lucia')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('208','St. Martin')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('209','St. Pierre and Miquelon')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('210','St. Vincent and Grenadines')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('211','Sudan')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('212','Suriname')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('213','Svalbard &amp; Jan Mayen Islands')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('214','Swaziland')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('215','Sweden')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('216','Switzerland')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('217','Syria')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('218','Taiwan')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('219','Tajikistan')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('220','Tanzania')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('221','Thailand')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('222','Togo')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('223','Tokelau')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('224','Tonga')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('225','Trinidad and Tobago')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('226','Tunisia')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('227','Turkey')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('228','Turkmenistan')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('229','Turks and Caicos Islands')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('230','Tuvalu')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('231','Uganda')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('232','Ukraine')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('233','United Arab Emirates')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('234','United Kingdom')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('235','United States')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('236','Uruguay')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('237','US Outlying Islands')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('238','US Virgin Islands')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('239','Uzbekistan')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('240','Vanuatu')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('241','Vatican')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('242','Venezuela')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('243','Vietnam')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('244','Wallis and Futuna Islands')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('245','Western Sahara')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('246','Yemen')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('247','Zambia')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_country(cid,country)VALUES('248','Zimbabwe')";
mysql_query($sql,$conn);

$sql = "CREATE TABLE ph_lang(ID int NOT NULL AUTO_INCREMENT,PRIMARY KEY(ID),lid varchar(500),lang varchar(500))";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_lang(lid,lang)VALUES('1','Afrikaans')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_lang(lid,lang)VALUES('2','Amharic')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_lang(lid,lang)VALUES('3','Bulgarian')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_lang(lid,lang)VALUES('4','Catalan')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_lang(lid,lang)VALUES('5','Chinese(HongKong)')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_lang(lid,lang)VALUES('6','Chinese(PRC)')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_lang(lid,lang)VALUES('7','Chinese(Taiwan)')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_lang(lid,lang)VALUES('8','Croatian')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_lang(lid,lang)VALUES('9','Czech')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_lang(lid,lang)VALUES('10','Danish')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_lang(lid,lang)VALUES('11','Dutch')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_lang(lid,lang)VALUES('12','English')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_lang(lid,lang)VALUES('13','Estonian')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_lang(lid,lang)VALUES('14','Filipino')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_lang(lid,lang)VALUES('15','Finnish')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_lang(lid,lang)VALUES('16','French')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_lang(lid,lang)VALUES('17','German')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_lang(lid,lang)VALUES('18','Greek')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_lang(lid,lang)VALUES('19','Hebrew')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_lang(lid,lang)VALUES('20','Hindi')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_lang(lid,lang)VALUES('21','Hungarian')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_lang(lid,lang)VALUES('22','Icelandic')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_lang(lid,lang)VALUES('23','Indonesian')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_lang(lid,lang)VALUES('24','Italian')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_lang(lid,lang)VALUES('25','Japanese')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_lang(lid,lang)VALUES('26','Korean')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_lang(lid,lang)VALUES('27','Latvian')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_lang(lid,lang)VALUES('28','Lithuanian')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_lang(lid,lang)VALUES('29','Malay')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_lang(lid,lang)VALUES('30','Norwegian')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_lang(lid,lang)VALUES('31','Polish')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_lang(lid,lang)VALUES('32','Portuguese(Brazil)')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_lang(lid,lang)VALUES('33','Portuguese(Portugal)')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_lang(lid,lang)VALUES('34','Romanian')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_lang(lid,lang)VALUES('35','Russian')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_lang(lid,lang)VALUES('36','Serbian')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_lang(lid,lang)VALUES('37','Slovak')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_lang(lid,lang)VALUES('38','Slovenian')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_lang(lid,lang)VALUES('39','Spanish')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_lang(lid,lang)VALUES('40','Swahili')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_lang(lid,lang)VALUES('41','Swedish')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_lang(lid,lang)VALUES('42','Thai')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_lang(lid,lang)VALUES('43','Turkish')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_lang(lid,lang)VALUES('44','Ukrainian')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_lang(lid,lang)VALUES('45','Vietnamese')";
mysql_query($sql,$conn);
$sql = "INSERT INTO ph_lang(lid,lang)VALUES('46','Zulu')";
mysql_query($sql,$conn);
//创建图片表
// $sql = "CREATE TABLE ph_img(ID int NOT NULL AUTO_INCREMENT,PRIMARY KEY(ID),imgpath varchar(500),orderid int)";
// mysql_query($sql,$conn);
//创建公告表
// $sql = "CREATE TABLE ph_notice(ID int NOT NULL AUTO_INCREMENT,PRIMARY KEY(ID),title varchar(500),content text,c_time varchar(500),status varchar(500))";
// mysql_query($sql,$conn);
mysql_close($conn);
echo "<script language=JavaScript>\r\n";
echo "alert('安装成功!');\r\n";
echo "location.href='index.php'\r\n";
echo "</script>";
	}
	?>
    </div>
</div>
</body>
</html>
